UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'ZBGBcWYt3+hYev43c9XdTQDL06agtzRrNhKKrGA69+U='
WHERE
key_id = '86a2e7ee6187801f50441a6c8f00d9b5b501ebca8884338fd2918114ab4c36a4'
AND (
token = 'ZBGBcWYt3+hYev43c9XdTQDL06agtzRrNhKKrGA69+U='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)