UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'ACP9ttfu38w0fkaTKYcbc4SNA1GlpotMiKRLjdDqYV0='
WHERE
key_id = '97121f798f9819fe335ddc01bd6533ce80eb9ee78706a9473e3d98010ec515f1'
AND (
token = 'ACP9ttfu38w0fkaTKYcbc4SNA1GlpotMiKRLjdDqYV0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)