UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'XsVYm+IwPGD64mfAdTmdjM88l7d19hIm9JIqDhPxd+Q='
WHERE
key_id = '9124f9c8fdc299c0300ea1edcd00c777f2710b7eecc4d176784f7be90d64234c'
AND (
token = 'XsVYm+IwPGD64mfAdTmdjM88l7d19hIm9JIqDhPxd+Q='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)