UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'DZd8JUs+MFBwevOnbqe0viWD/+1iwfrYWfG2XxDZUyM=' 
WHERE 
  key_id = 'ca204635f813999715239e11658e2a8912b6510359c223e4b334b7f76158718e' 
  AND (
    token = 'DZd8JUs+MFBwevOnbqe0viWD/+1iwfrYWfG2XxDZUyM=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00053