UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'DzwVoyh6th276mRWvXzI9prbmz3o2KYOv2KzZ/S4vgc=' 
WHERE 
  key_id = 'd44f7dabe2243a9342fa489065606cb9686214f0b234f2ac42d6b2d05e493e74' 
  AND (
    token = 'DzwVoyh6th276mRWvXzI9prbmz3o2KYOv2KzZ/S4vgc=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00027