UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'DCP07fGBdTB0ardZzUZ0ojcX1nZB9zJt8vt1x/Qd7wU=' 
WHERE 
  key_id = '073bdc3ab52266b6feaf427615e6174b42a23040af28a50935c89ba93fa741ee' 
  AND (
    token = 'DCP07fGBdTB0ardZzUZ0ojcX1nZB9zJt8vt1x/Qd7wU=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00033