UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'UiKHp7iDJIGPVIo9xEFatUOW8/MTyWYWq+HalqFGmgk='
WHERE
key_id = '8b101dd9f45e1bb60ef0331b63e8cf81f547502723c805fc543ae35f14050587'
AND (
token = 'UiKHp7iDJIGPVIo9xEFatUOW8/MTyWYWq+HalqFGmgk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)