UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '3vxksKaB9GXnJaNubo2PmKxR1Hei2hLvqIF3XMsjxcE='
WHERE
key_id = '79a74255cd6514054d1105ccd714b09a81cec2bfdf26b5633656cd508ef7512e'
AND (
token = '3vxksKaB9GXnJaNubo2PmKxR1Hei2hLvqIF3XMsjxcE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)