UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'gE7bZVj+2IkwckE+jAP7tAcR8xYm1mvZJMAKO4PZ2i8='
WHERE
key_id = 'fd8805e5bf1e291b905d3990b9c62053fcc0caa344b758b29b24eb229886c01f'
AND (
token = 'gE7bZVj+2IkwckE+jAP7tAcR8xYm1mvZJMAKO4PZ2i8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)