UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'HfYko0apIEl5mEKI3Nm4YIkWOBdjDqv/naD3EO4pNyU='
WHERE
key_id = '9d7293c18edfc36a89be7e89d07b7328031392d165c45211bd07c2d9bc3358ba'
AND (
token = 'HfYko0apIEl5mEKI3Nm4YIkWOBdjDqv/naD3EO4pNyU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)