UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'vJ4Le7HNu+xwD1FqB0E+ymjl5l/r8D+tke78Wd62hqE=' 
WHERE 
  key_id = '5ccdfe5595e2eac51d5b157821d4f0ddc96840b6e0c0acee820c1cf8f1f8d2ae' 
  AND (
    token = 'vJ4Le7HNu+xwD1FqB0E+ymjl5l/r8D+tke78Wd62hqE=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00020