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