UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'ZXB/T0jFBD7ClbSwVWq3zk83xT5pwfHjJrMxF2dldIc='
WHERE
key_id = '6ce03626d81dd3bd921b26671459aae62504592ac1a22a52feb41e9eca79fcf9'
AND (
token = 'ZXB/T0jFBD7ClbSwVWq3zk83xT5pwfHjJrMxF2dldIc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)