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