UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'q/DdaJaNafqVJnQUdNV7F29r6Fg29F5Drmd87pz1UR4='
WHERE
key_id = '1a6d09b76ddb6a92664d8516b0968bf28462e00831297f30c8a0203a7de1c9eb'
AND (
token = 'q/DdaJaNafqVJnQUdNV7F29r6Fg29F5Drmd87pz1UR4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)