UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'BbiqoPnIIqGX0FJt9/pJocaJ67zlIBOwarf1TwXj9oA='
WHERE
key_id = 'b1e5f314b5ca41f070782df5f5ff469b44d24ef2914c04c422260abe1a1a2c97'
AND (
token = 'BbiqoPnIIqGX0FJt9/pJocaJ67zlIBOwarf1TwXj9oA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)