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