UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'd0+s5rOT93ZPAyNDSq7JUyKn5Oh3505rdlsWWXAxa/s=' 
WHERE 
  key_id = '498484252a0e66e7f3eea6d680678f6393c0e1d893f2580dda55e1b4c02abef0' 
  AND (
    token = 'd0+s5rOT93ZPAyNDSq7JUyKn5Oh3505rdlsWWXAxa/s=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00024