UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'f7GAktXmE+cgI1mWqS9lpKv5fYcsBXEbwsF7IQcVpK0='
WHERE
key_id = '78a4981f156b33b3723ff9c95f3314ecfc36c2e286c0cb45fe236bb4fcec02e9'
AND (
token = 'f7GAktXmE+cgI1mWqS9lpKv5fYcsBXEbwsF7IQcVpK0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)