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