UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'o4gsnuyh6Lg8XMdJ4MfA6IoZIIRrd6WI1bIT+sHgKik='
WHERE
key_id = '8fed3eef5eee0a77e292df1a2f7311525df71dedb186911919a3e4f4da896072'
AND (
token = 'o4gsnuyh6Lg8XMdJ4MfA6IoZIIRrd6WI1bIT+sHgKik='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)