UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'ZzqsAN0lSB6vjCPrKIsMctmrR8dkloPZxC3to+rBNjU='
WHERE
key_id = '2ad2a4fdb37c00ac78af9ab3fd6a0ecc8aac74b056316e67b27f3fddf6a180bf'
AND (
token = 'ZzqsAN0lSB6vjCPrKIsMctmrR8dkloPZxC3to+rBNjU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)