UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'TBsfoDIl/f4JbMCSbgjmQcxrttWP7NijpxUlCD1zzcQ='
WHERE
key_id = '0c39d0ee4b57dd86a4465ac32f6f47a03149a098b9e9d0e07a47e51a310c3510'
AND (
token = 'TBsfoDIl/f4JbMCSbgjmQcxrttWP7NijpxUlCD1zzcQ='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)