UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '9acCCWCpfzC7kppKry5ftC82sbrnsWjSLv2jlRpW3Nc='
WHERE
key_id = '61b9de27337f9bb0672733ce23d89e8ce84ebcb59f9a5fcf564e3869e6b29493'
AND (
token = '9acCCWCpfzC7kppKry5ftC82sbrnsWjSLv2jlRpW3Nc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)