UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'vZ7jbmbp8zShKBIbmnAMWIXtiO6u3Ammu6djJCONtn4='
WHERE
key_id = '2ee43196a4a0336be98d08b4c8f4d0537a302fd7c33e4c863f432b757baf55e0'
AND (
token = 'vZ7jbmbp8zShKBIbmnAMWIXtiO6u3Ammu6djJCONtn4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)