UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Xh6yTE3XjQl4jsVIT73XOV4ZWTKi4Wn2ltRXkq2ITBs='
WHERE
key_id = 'dee1f503d233280f024070fdf42815aefc9e703c7efce455f3c3178b001f1d43'
AND (
token = 'Xh6yTE3XjQl4jsVIT73XOV4ZWTKi4Wn2ltRXkq2ITBs='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)