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