UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'cWHREvBsYaPjMXG4F+4lwIU6Bx0cZIHgvKjjY0pcraY='
WHERE
key_id = 'af4f1bbcaf8579c8a2c5646e71c640e5d0d630884bca985bf0909eb6f7b3e218'
AND (
token = 'cWHREvBsYaPjMXG4F+4lwIU6Bx0cZIHgvKjjY0pcraY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)