UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'RsW7F/MtXYqAfO8FNUABgYAu37egu1QXgyc0uidj5iM='
WHERE
key_id = 'bc8ba6d3934281b23ee25fd31765e5d0b1f9b26dcd31797956d71fb68f0ac255'
AND (
token = 'RsW7F/MtXYqAfO8FNUABgYAu37egu1QXgyc0uidj5iM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)