UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'OuzNQKSKeL5oxM36tOcwCtcXU5dA/BB7Pf0Bg6K5HwI=' 
WHERE 
  key_id = '6cdc98d3d9e7c6f6e4434783d77475952540e99a4e82c90a611b111a1fa75865' 
  AND (
    token = 'OuzNQKSKeL5oxM36tOcwCtcXU5dA/BB7Pf0Bg6K5HwI=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00023