UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'ZFfgH6zYpZP3OJgn5oSmS/1lKxQK1SW6v9zOfyrv2R8='
WHERE
key_id = 'a400856467d77b7fe16779352c372d0fbf3e1715b4b89494b38e365739b61c9e'
AND (
token = 'ZFfgH6zYpZP3OJgn5oSmS/1lKxQK1SW6v9zOfyrv2R8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)