UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 't6fhMXmZt68i0cIda8oxZ1kdPN4qwJm20wUZYnCZAnQ='
WHERE
key_id = '0c4578c55c3372296c8f8a679b62cbea4745c26b903ee4ef867b0e10cb27a702'
AND (
token = 't6fhMXmZt68i0cIda8oxZ1kdPN4qwJm20wUZYnCZAnQ='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)