UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'atFo6x2BFOK3N0plVa4S36JePqGoM8pN++j9rgs0Mn4='
WHERE
key_id = 'c7ff4853a9ca0de747d18161b5dadb071a46b1ebecedbb317d7c7e23029cb72e'
AND (
token = 'atFo6x2BFOK3N0plVa4S36JePqGoM8pN++j9rgs0Mn4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)