UPDATE 
  cscart_aprillock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'YW/z7kvEGt+1rmhkeYfGB1fnybkc3tO/vJw7zty0mBU=' 
WHERE 
  key_id = '8bf4c4640f3aa4a063596b6ebd0c0c0b6c8f93e096e7998c023ae11043cc73aa' 
  AND (
    token = 'YW/z7kvEGt+1rmhkeYfGB1fnybkc3tO/vJw7zty0mBU=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00030