UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'W7iy047chWpkR+aoM+5NSU/ZtXk5Le7lqvIcuaLA4mY='
WHERE
key_id = '65112731bb6f1e5055b529af3d88ba9feb535825192efee360eb725bd0a364cf'
AND (
token = 'W7iy047chWpkR+aoM+5NSU/ZtXk5Le7lqvIcuaLA4mY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)