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