UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'NY8mKDJXtF/3ywuAv1WJoiYrD0oVh4j8XN38Z72P/C4=' 
WHERE 
  key_id = '15596fb37164ad7f9c2ab5cbafa4127af772980f0f1f75c75089a321503a650c' 
  AND (
    token = 'NY8mKDJXtF/3ywuAv1WJoiYrD0oVh4j8XN38Z72P/C4=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00021