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