UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = '9fIK3xdx36WxIOuvbRHbejO8CuKL51fK5kSBcAiF1zU=' 
WHERE 
  key_id = 'bc91a514d15df94c33bb7df4d6ee7e3696e8c5f3e9627085a81e4956784c6331' 
  AND (
    token = '9fIK3xdx36WxIOuvbRHbejO8CuKL51fK5kSBcAiF1zU=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00023