UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'x8zcBT/xgG/aGUCj5QB0uKtF0zXup5QXIk6V2jkGw6w=' 
WHERE 
  key_id = '8bbb23b7f34e3d32e5201c0b1f7dbaf57cd707143f0782dd06b992614e2b286f' 
  AND (
    token = 'x8zcBT/xgG/aGUCj5QB0uKtF0zXup5QXIk6V2jkGw6w=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00024